/* 
 *
 * Persistence4J - Simple library for data persistence using java
 * Copyright (c) 2010, Avdhesh yadav.
 * http://www.avdheshyadav.com
 * Contact: avdhesh.yadav@gmail.com
 *
 * This library is free software; you can redistribute it and/or modify it under the terms
 * of the GNU Lesser General Public License as published by the Free Software Foundation,
 * either version 3 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA 02111-1307, USA.
 *
 */

package com.avdy.p4j.jdbc.common;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 
 *  @author Avdhesh Yadav  
 *
 */
public class GenericCRUD implements CRUD
{
	/**
	 * 
	 */
	public GenericCRUD()
	{
		
	}
	
	
	/**
	 * 
	 * @param pstmt PreparedStatement
	 * 
	 * @return boolean
	 * 
	 * @throws SQLException
	 */
	public boolean create(PreparedStatement pstmt)throws SQLException
	{
		synchronized (this)
		{
			int i = pstmt.executeUpdate();
			return  (i== 0) ? false : true;
		}
	}

	/**
	 * 
	 * @param pstmt PreparedStatement
	 * 
	 * @return boolean
	 * 
	 * @throws SQLException
	 */
	public int[] batchInsert(PreparedStatement pstmt)throws SQLException
	{
		synchronized (this) 
		{
			return pstmt.executeBatch();
		}
	}
	
	
	/**
	 * 
	 * @param pstmt PreparedStatement
	 * 
	 * @return ResultSet
	 * 
	 * @throws SQLException
	 */
	public ResultSet read(PreparedStatement pstmt)throws SQLException
	{
		synchronized ( this )
		{
			return pstmt.executeQuery();
		}
		
	}

	
	/**
	 * 
	 * @param pstmt PreparedStatement
	 * 
	 * @return boolean
	 * 
	 * @throws SQLException
	 */
	public boolean update(PreparedStatement pstmt)throws SQLException
	{
		synchronized (this) 
		{
			int i = pstmt.executeUpdate();
			return  (i== 0) ? false : true;
		}
	}

	
	/**
	 * 
	 * @param conn Connection
	 * @param query String
	 * 
	 * @return boolean
	 * 
	 * @throws SQLException
	 */
	public	boolean delete(Connection conn, String query)throws SQLException
	{
		synchronized (this) 
		{
			PreparedStatement pstmt = conn.prepareStatement(query);
			int i = pstmt.executeUpdate();
			pstmt.close();
			return  (i== 0) ? false : true;
		}
	}
}